System Properties ODBC page

Profiles

Functionality:

  1. Data Sources ComboBox ("Datebook") - select an available data source to connect
  2. Tables ComboBox ("AGOSTO.TXT") - once connected contains a list of tables for that data source; selecting a table causes its structure to appear in the Results panel
  3. PK - displays Primary Keys for selected table if available
  4. FK - displays Foreign Keys for selected table if available
  5. Print... button - prints the result set
  6. List View - Result Set of any operation displayed here
  7. Drivers TreeView - lists available drivers and their characteristics
  8. SQL Edit Box - type any SQL statement for available data source to execute
  9. EXECUTE button - executes SQL typed into edit box
  10. Insert button - places "insert into [tablename] () values ()" into SQL EditBox for editing and execution
  11. Update button - places "update [tablename] set" into SQL EditBox for editing and execution
  12. Delete button - places "delete [tablename] where" into SQL EditBox for editing and execution
  13. History ComboBox - retains all executed statements on current datasource for recall and modification
  14. Connect button - connects to a datasource via a Dialog Box
  15. Disconnect button - disocnnects currently connected datasource
  16. Stats button - displays Statistics for selected table if available
  17. Manage Data Sources button - opens ODBC Manager dislog box to add/edit/delete datasources

Index